SQL Server Spatial Requirements

Supported versions of SQL Server:

SQL Server stores spatial data using one of two data types.

Name	Data type	SRID
Geography	Latitude/longitude	Required. Typically 4326 for WGS84, 4269 for NAD83
Geometry	Cartesian coordinates	Optional but strongly recommended.

Note: SRIDs are referenced by EPSG number.

Select * from sys.spatial_reference_systems

-- select SRID by text

Select * from sys.spatial_reference_systems where well_known_text
like '%ED50%'